package team.ttorder.ttorder.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import team.ttorder.ttorder.model.FoodType;
import team.ttorder.ttorder.mymapper.MyMapper;

public interface FoodTypeMapper extends MyMapper<FoodType> {

	@Select("select id as id, type_name as typeName from food_type where type_name = #{name}")
	public FoodType selectByFoodTypeName(String name);

	@Select("select id as id, type_name as typeName from scott.food_type WHERE 1=1 order by CONVERT( type_name USING gbk ) COLLATE gbk_chinese_ci ASC")
	public List<FoodType> getAllFoodType();
}
